Excel recovered files

Location of Excel recovery workbooks in your system when Excel crashes, it ...

Filename_Clean

Returns cleaned file name of invalid characters. Needs to be modified if used ...

Dropdown button commands

A drop-down of multiple commands in pure VBA. Needed this in a large Excel-VBA ...

DropdownButton.zip

LstCustomSelection_Refresh

Read list of items from Settings sheet, then Sort, then save, before reading ...

DBTables

Returns an array of all table names in a database. needs valid OLE database ...

Frm81 - FullDetails

Show window of details, can be used to show content for certain cell, or show ...

Frm81.zip

ShapeRange_BG

Replaces the background fill of any shape in Excel with an image Not Ready yet, ...

Regular expressions (Notepad++)

How to do regular expressions in Notepad ++ search and/or replace Helpful when ...

File2Body

Reads file and showing it as Bootstrap row, with ability to replace variables ...

CountDuplicates

Counts how many duplicates found in a range of Excel cells. Basically how many ...

ListBox_Excel_Sort

Sort items in Fm20 Listbox using Excel spreadsheet Sort function. Can decide ...

Sorting Strings

This is not a function as much as a note. I needed to force a line to show at ...